CREATE  external TABLE jms_dwd.dwd_yl_meeting_video_upload_dt
(
ID bigint COMMENT '主键ID'
,VIDEO_TIME string COMMENT '视频时长'
,TITLE string COMMENT  '标题'
,DES string COMMENT  '视频描述'
,COMMIT_TIME date COMMENT  '提交时间'
,APP_ACCOUNT string COMMENT 'APP账号'
,APP_ACCOUNT_NAME string COMMENT 'APP账号名称'
,NETWORK_NAME string COMMENT '所属网点名称'
,NETWORK_CODE string COMMENT  '网点CODE'
,NETWORK_ID string COMMENT '网点ID'
,VIDEO_CONTENT string COMMENT  '视频内容'
)partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_dwd.db/external/dwd_yl_meeting_video_upload_dt'
tblproperties(
'discover.partitions'='false',
'parquet.column.index.access'='true');